Translate into your language!

Date Calculator

Overview

This function calculates different versions of a given date.

How to Invoke

Use the menu item "Utilities > Calculators > Date Calculator" .

Basic Procedure

Window Controls

"Enter Date " control

Enter the date you want calculated in the Date control.

"Calculate" button

This calculates and converts the different date formats:
  1. "Day of Week" : reckoned as Sunday = 1, Saturday = 7
  2. Day of Year: reckoned with January 1st being the first day of the year
  3. "Week of Year" : reckoned with the week on which January 1st falls as being the first week of the year
  4. "Short Date" : this is based on your locale and formatting (using both Windows and Macintosh's 'Short' setting)
  5. "Abbreviated Date" : this is based on your locale and formatting (using Macintosh's 'Medium' date setting and an abbreviated version of Windows' 'Long' setting)
  6. "Long Date" : this is based on your locale and formatting (using Macintosh's 'Full' date setting and an abbreviated version of Windows' 'Long' setting)
  7. "SQL Date" : this displays in YYYY-MM-DD format
  8. "Julian Day" : this displays the number of days since the beginning of the Julian Period (November 24, 4714 BC in the Gregorian Calendar)
  9. "Kali Day" : this displays the number of days since the beginning of Kali Yuga (January 14, 3102 BC in the Gregorian Calendar).
  10. "Excel Serial Date" : this displays the number used by Microsoft's Excel spreadsheet for storing dates.

Note

On Windows, the Regional and Language Options panel determines how dates are formatted. On Macintosh, the date formats are specified in the Formats panel in the International control panel.